Let me start off by saying that there are no gaurantees whatsoever with this spreadsheet. Trading futures involves risk. That means you can loose money!! If you decide to use the signals generated in this spreadsheet, do not complain to me if you loose money. But if you do make money with it, please let me know.
If you like this spreadsheet and want to see more of them please send me $5 (or a 12-pack o' beer) to:
Kevin Riley - KOR Trader
1300 Adams St # 24C
Costa Mesa, CA 92626
If you have any questions about this spreadsheet then send E-mail
I decided to develop this system after reading "Capturing Full-Trend Profits in the Commodities Futers Markets" by Colon Alexander. The system he describes is called the Wellspring System. This is simply an adaptation of it.
This spreadsheet will analyze Commodity price data and will kick out buy/sell recomendation and compute a resonable stop-loss. The last part of the spreadsheet will determine the profitability of the position after ten days if it wasn't stopped out. I know this is a very limited test but it can be interesting. The real test is to papertrade using your own criteria for exiting the market. Also, it will assume that you entered the market on the open of the next day. (Another limitation, if you don't like, change it!)
INSTRUCTIONS
There are three files, this one, KOR Temp, and KOR Temp Macro. You do not need to change the names of these files.
You will will need to have price data in the following order:
Date, Open, High, Low, Close, Volume, Open Interest
The data should be in ASCII format, tab deliminated.
Now here is the hard part. When you open KOR Temp, press the button that says "Get Data". Select the data file you want to use and open it. When it done getting the data and recalculating the worksheet, it will prompt you to enter the name of the new file. Thats all there is to it! (Pretty tough eh?)
Look in the Buy/Sell column to see if there is a signal for that day. The reason the signal was given can be seen in the columns to the left.
Because of the amount of calculations involved with this spreadsheet, you might want to keep the data under 200 trading days. If you get an alert that says that the selection is too big for undo, don't worry, just click "Ok" and it will continue. You might want to get up and get a cup of coffee or something at this point because it will take a few minutes. Also, you might run the risk of running out of memory if you try to input a large amount of data.
